Release 10.1A: OpenEdge Data Management:
SQL Development

Creating database administrators

Database security is defined and controlled by database administrators (DBAs). Within the scope of database security, DBAs are responsible for:

Adding users.
Deleting users.
Permitting access to specific database objects.
Limiting or prohibiting access to database objects.
Granting users privileges to view or modify database objects.
Modifying or revoking privileges that have been granted to the users.

A user who initially creates a database becomes its default administrator. Therefore, this initial user has the authority to create other administrator accounts for that particular database.

OpenEdge Studio offers two methods for creating DBAs:

In SQL, the DBA uses the CREATE statement to create a user and then uses the GRANT statement to provide the user with administrative privileges.
In Progress 4GL, a DBA uses the Data Administration Tool to create other administrators.